[dbo].[asi_CancelPendingPublishRequest]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_CancelPendingPublishRequest

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@PublishRequestKey	uniqueidentifier	16
@PublishServerCode	nchar	1

SQL Script

CREATE PROCEDURE [dbo].[asi_CancelPendingPublishRequest]
    @PublishRequestKey uniqueidentifier,
    @PublishServerCode nchar(1)AS
BEGIN
    UPDATE PublishRequestDetail
       SET PublishRequestStatusCode = 2 --canceled
     WHERE PublishRequestKey = @PublishRequestKey
       AND PublishServerCode = @PublishServerCode
       AND PublishRequestStatusCode = 0 -- New
END

SET ANSI_NULLS ON

GO

Uses

[dbo].[PublishRequestDetail]
dbo